Audit files for the French legislation were introduced in product update 404. For more information, see Product Updates 405 and 404: Audit files can be generated (French legislation).
To comply with the latest tax regulation in France, the check box Include: Opening balance has been added to the Audit file screen to provide you with the option to include opening balances in your audit file submission to the tax authorities.
A new field named Journal code has been made available under the Export file section along with the Include: Opening balance check box. This field will be enabled only if the Include: Opening balance check box has been selected. You can type any value at Journal code with a maximum of five alphanumeric characters. However, the journal code defined should not exist in the Exact Globe administration.
In cases where the optional Include: Opening balance feature is enabled, the XML content will display the opening balances at the top, followed by the transaction records.
Generally, for balance sheet general ledger accounts, the opening balances reflect total amounts before the selected start date. The opening balances involving both the debtor and creditor general ledger accounts are displayed per debtor or creditor. For profit and loss general ledger accounts, the opening balances reflect “0”.
In addition, any general ledger accounts starting with “8” or “9”, and opening balances having zero amounts are not reported. Only opening balances which the debit and credit amounts match in the general ledger accounts will be included. The symbol “.” is used as the decimal separator regardless of the value preset in the regional settings. Any special characters used for describing the journals and entries will be replaced with blank spaces. Also, closing entries are omitted from the transaction list in the audit file.
You can still proceed to generate and export the audit files for any date range having no transactions with the Include: Opening balance feature enabled. For samples of the XML file, see XML sample for French audit file.